// 核销明细表
const {DataTypes, db } = require("../db");
db.define('hxInfo', {
id: {type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true,comment:'表自增ID'},
tenantId:{type: DataTypes.INTEGER,comment:''}, 
iid:{type: DataTypes.INTEGER,comment:'主表ID'}, 
type:{type: DataTypes.STRING(10),comment:'hx|bill'}, 
billId:{type: DataTypes.INTEGER,comment:''}, 
billNo:{type: DataTypes.STRING(30),comment:''}, 
billDate:{type: DataTypes.STRING(1),comment:''}, 
arrears:{type: DataTypes.FLOAT,comment:''}, 
hxAmount:{type: DataTypes.FLOAT,comment:''}, 
leftAmount:{type: DataTypes.FLOAT,comment:''}, 
nowCheck:{type: DataTypes.FLOAT,comment:''}, 
remark:{type: DataTypes.STRING(255),comment:''}, 

}, {
    tableName: 'hx_info',
    timestamps: false,
    comment: '核销明细表'
});